This relational database template consists of the Projects file and the Project Tasks file. These two database files work together to keep track of projects and the specific tasks that need to be accomplished to complete each project. The Projects file keeps track of general information such as project name, status, description, milestones, and resources. The Project Tasks file contains details about the specific tasks, such as the task's status, cost, and headcount.
How to u
se this template
Start by defining the whole project in the Projects database. Then, name each task and fill out as much of the other information as you know. If you click the arrow button to the right of the task information, the Project Tasks database is opened and brought to the front. Finish filling out the task information, and then click the arrow button to the right of the Project Name to return to the Projects file.
How to customize this template
You can create custom reports to o
NotesB
InfoB
Created ByB
Last LayoutB
A List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Status
Finish
Start
Manager
Status
Finish
Start
Project Name
Enter data for Projects
Close
View As
View As
Reports
Record
Delete
Record
Record
Your Own
Button
Your Own
Button
Resources &
Notes
Tasks
Projects
Tasks File...
Project ID
Resources &
Notes
Tasks
Projects
Tasks File...
Project ID
Project ReportB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Statusc
Finishd
Starte
Managerf
Project Nameg+Click to see more information for a Projectr
Infos
Closet
View As
Formu
View As
Listv
Reportsw
Recordx
Delete
Recordy
Recordz
Your Own
Button{
Your Own
Button|
InformationB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Description
Status
Finish
Start
Manager
Project
Page ##
Project Report
Close
View As
View As
Reports
Your Own
Button
Tasks
Project Report
Benefit Return
Notes
Description
Status
Finish
Start
Manager
Project
Page ##
Project Report
Close
View As
View As
Reports
Your Own
Button
Tasks
Project Report
Benefit Return
Notes
Report MenuB
P'Information about the Projects solutionQ
Info for this SolutionR
InfoS
CloseT
View As
FormU
View As
ListV
ReportsW
Your Own
Button
View As
FormU
View As
ListV
ReportsW
Your Own
Button
Your Own
ReportI
Your Own
ReportJ
Project ReportK
Your Own
ReportL>Click on any of these buttons to preview the respective reportM
Select a reportN
InfoO
CloseP
View As
FormQ
View As
ListR
ReportsS
Your Own
Button
on any of these buttons to preview the respective reportM
Select a reportN
InfoO
CloseP
View As
FormQ
View As
ListR
ReportsS
Your Own
Button
Form View - Resources and NotesB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
InfoI
CloseJ
View As
FormK
View As
ListL
ReportsM
Your Own
Button
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
[&Enter Resources and Notes for Projects
Close
View As
View As
Reports
Record
Delete
Record
Record
Your Own
Button
Your Own
Button
Resources &
Notes
Tasks
Projects
Tasks File...
Benefit Return
Notes
Project ID
Project Name
Project Manager
Project Description
Start
Finish
Status
1C>Design and implement new internal capital depreciation system.E
Sales AutomationG$Better management of capital assets.H
FarnsworthY
10/8/95a
On Schedule
Develop a customer tracking database for use by both sales and marketing. Multi-user system with local and remote access. Must store in the thousands of records without getting sluggish.E
Customer Tracking 90GXIncrease sales by 2.3 million by using current customer list to sell our other products.H
JohnsonY
10/8/95a
Ahead
Launch new tent fabric product.E
Launch TimeG!Increase product sales by 15-20%.H
Lori EmmetY
10/8/95a
Behind
4CXDevelop pricing policy involving such factors as product category, margin, and supplier.E
Pricing StrategyG'Attain a standardized pricing strategy.H
Billy AdlingtonY
10/8/95a Completed
5CDEstablish 3 new sales offices in Chicago, Boston, and San Francisco.E
Site Project 1990G9Increase penetration of these market areas by $1 million.H
SmithY
10/8/95a
On Schedule
InfoI
CloseJ
View As
FormK
View As
ListL
ReportsM
Your Own
Button
Information
A List View
Report Menu
Sort by Project Start Date
Sort by Project Status
Close Project Tasks
HP DeskJet 540 Printer
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.E+
) = 1
Information
List View
Report Menu
Sort by Project Name
Sort by Project Start Date
Sort by Project Status
Project Report
Open Script
Close Project Tasks
Sort by Project Name
Project Report
Open Script
<2/1/96
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
/MSPC
FPTHA/SCSI Disk 20:JC:Ken's:COMPAT FUL:Project Tasks
FPTHAcMacintosh 840av:FileMaker Pro 3.0 Folder:FileMaker Templates:Business:Projects System:Project Tasks
MSPCA
NAMEA
Project Tasks
RPTHA
Project Tasks
SRPTA tasks.fp3
FMP3FMP3
Projects System
cMacintosh 840av:FileMaker Pro 3.0 Folder:FileMaker Templates:Business:Projects System:Project Tasks
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
wwwwww
UUUUUU
DDDDDD
""""""
wwwwww
ffffff
UUUUUU
DDDDDD
333333
wwwwww
ffffff
UUUUUU
DDDDDD
333333
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
"%UR
UD33D
#4EWp
"4EVx
#3EVg
"4DUg
#3EVg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
" 234DUfw
2""2334DEVgx
3 4DEUfwx
3 DDUVgw
D EUUfwx
UDDEUUfgw
U Vfgwx
eUVfgww
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"#C0
4""#C0
AD@D@
AD@D@
AD@BL
44444
CCCCC 44444 CCCCC
$42"
bRBBP0
wwwwww
ffffff
UUUUUU
DDDDDD
@@BA@
UUUUUU
wwwwww
(*)(%,3&
)%+@6)
",30,)%
#*>A6332+$"!
25,878
#&$690*"
!)0,++)(
"%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*
!$&(265389,#!$$
'275?
" $$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<
/2583$%+66/%
%)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
$$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
!$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!
//6B&
#'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+,)+"
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!PQ
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGCA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
%'0>GFA:378+&&%$$,&
,:CPQ
$(,027CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
#%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
876=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,
169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,*3*)-/0/+&$$!
6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7)
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
&46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
#'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$
"03., PQ
Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
Project DescriptionB
Project NameB
Benefit ReturnB
Project ManagerB
Date CreatedB
Date ModifiedB
Project StatusB
Not Started
Total CostB
Project Start DateB
Project Finish DateB
Grganize the data. For instance, the report layout included in the Project Tasks file shows the tasks for each person on the team. You might want to organize the tasks by date or status.
If you have a regular team, you might want to use a value list to help you enter their names in the Task Manager and Project Manager fields.
(LIST
LISTA0Not Started
Ahead
On Schedule
Behind
Completed
VDEFA(
Project Status List
FMRLA
Project Tasks
Macintosh 840av
Project Tasks
FMP3FMP3
Projects System
cMacintosh 840av:FileMaker Pro 3.0 Folder:FileMaker Templates:Business:Projects System:Project Tasks
(.txt)